<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>主要内容区main</title>
    <link href="../../public/admin/css/css.css" type="text/css" rel="stylesheet" />
    <link href="../../public/admin/css/main.css" type="text/css" rel="stylesheet" />
    <link rel="shortcut icon" href="../../public/admin/img/main/favicon.ico" />
    <style>
        body{overflow-x:hidden; background:#f2f0f5; padding:15px 0px 10px 5px;}
        #searchmain{ font-size:12px;}
        #search{ font-size:12px; background:#548fc9; margin:10px 10px 0 0; display:inline; width:100%; color:#FFF; float:left}
        #search form span{height:40px; line-height:40px; padding:0 0px 0 10px; float:left;}
        #search form input.text-word{height:24px; line-height:24px; width:180px; margin:8px 0 6px 0; padding:0 0px 0 10px; float:left; border:1px solid #FFF;}
        #search form input.text-but{height:24px; line-height:24px; width:55px; background:url(../../public/admin/img/main/list_input.jpg) no-repeat left top; border:none; cursor:pointer; font-family:"Microsoft YaHei","Tahoma","Arial",'宋体'; color:#666; float:left; margin:8px 0 0 6px; display:inline;}
        #search a.add{ background:url(../../public/admin/img/main/add.jpg) no-repeat -3px 7px #548fc9; padding:0 10px 0 26px; height:40px; line-height:40px; font-size:14px; font-weight:bold; color:#FFF; float:right}
        #search a:hover.add{ text-decoration:underline; color:#d2e9ff;}
        #main-tab{ border:1px solid #eaeaea; background:#FFF; font-size:12px;}
        #main-tab th{ font-size:12px; background:url(../../public/admin/img/main/list_bg.jpg) repeat-x; height:32px; line-height:32px;}
        #main-tab td{ font-size:12px; line-height:40px;}
        #main-tab td a{ font-size:12px; color:#548fc9;}
        #main-tab td a:hover{color:#565656; text-decoration:underline;}
        .bordertop{ border-top:1px solid #ebebeb}
        .borderright{ border-right:1px solid #ebebeb}
        .borderbottom{ border-bottom:1px solid #ebebeb}
        .borderleft{ border-left:1px solid #ebebeb}
        .gray{ color:#dbdbdb;}
        td.fenye{ padding:10px 0 0 0; text-align:right;}
        .bggray{ background:#f9f9f9}
    </style>
</head>
<body>
<!--main_top-->
<table width="99%" border="0" cellspacing="0" cellpadding="0" id="searchmain">
    <tr>
        <td width="99%" align="left" valign="top">您的位置：帖子管理&nbsp;&nbsp;>&nbsp;&nbsp;查看帖子</td>
    </tr>
    <tr>
        <td align="left" valign="top">
            <table width="100%" border="0" cellspacing="0" cellpadding="0" id="search">
                <tr>
                    <td width="90%" align="left" valign="middle">
                        <form action="return.php?name=<?php echo @$_GET['name']?>" method="get">
                            <span>管理员：</span>
                            <input type="text" name="name" value="<?php echo @$_GET['name']?>" class="text-word">
                            <input type="submit" value="查询" class="text-but">
                        </form>
                    </td>
                    <td width="10%" align="center" valign="middle" style="text-align:right; width:150px;"><a href="add.html" target="mainFrame" onFocus="this.blur()" class="add">新增管理员</a></td>
                </tr>
            </table>
        </td>
    </tr>
    <tr>
        <td align="left" valign="top">

            <table width="100%" border="0" cellspacing="0" cellpadding="0" id="main-tab">
                <tr>
                    <th align="center" valign="middle" class="borderright">编号</th>
                    <th align="center" valign="middle" class="borderright">主题</th>
                    <th align="center" valign="middle" class="borderright">发帖人</th>
                    <th align="center" valign="middle" class="borderright">板块</th>
                    <th align="center" valign="middle" class="borderright">状态</th>
                    <th align="center" valign="middle" class="borderright">发表时间</th>
                    <th align="center" valign="middle">操作</th>
                </tr>

                <?php

                $link = mysqli_connect("localhost","root","") or die("数据连接失败");
                mysqli_set_charset($link,"utf8");
                mysqli_select_db($link,"bbs");

                if(empty(@$_GET['name'])){
                    $sql = "select post.*,user.userName,type.name from post,user,type where post.uid =user.id and post.tid=type.id and recycle='1' order by top desc,ctime desc";
                    $res = mysqli_query($link,$sql);
//
                    $count = mysqli_num_rows($res);//总条数；
                    $pages = ceil($count/10);//总页数；
                    $page = isset($_GET['p']) ? $_GET['p'] : 1;
                    if ($page < 1) {
                        $page = 1;
                    }
                    if ($page > $count) {
                        $page = $count;
                    }
                    $index = ($page - 1) * 10;
                    $sql = "select post.*,user.userName,type.name from post,user,type where post.uid =user.id and post.tid=type.id and recycle='1'  order by top desc,ctime desc limit $index,10";

                    $res = mysqli_query($link,$sql);
                    if($res && mysqli_num_rows($res)>0) {
                        while ($rows = mysqli_fetch_assoc($res)) {
                            if ($rows['recycle'] == 1) {


                                $time = date('Y-m-d H:i:s', time());
                                echo "<tr onMouseOut='this.style.backgroundColor='#ffffff'' onMouseOver='this.style.backgroundColor='#edf5ff''>";
                                echo "<td align='center' valign='middle' class='borderright borderbottom'>{$rows['id']}</td>";
                                echo "<td align='center' valign='middle' class='borderright borderbottom'>{$rows['title']}</td>";
                                echo "<td align='center' valign='middle' class='borderright borderbottom'>{$rows['userName']}</td>";
                                echo "<td align='center' valign='middle' class='borderright borderbottom'>{$rows['name']}</td>";
                                echo "<td align='center' valign='middle' class='borderright borderbottom'>" . '发布' . "</td>";
                                echo "<td align='center' valign='middle' class='borderright borderbottom'>{$time}</td>";
                                echo "<td align='center' valign='middle' class='borderbottom'><a href='doaction.php?a=recover&id={$rows['id']}' target='mainFrame' onFocus='this.blur()' class='add'>恢复</a>
                                    <span class='gray'>&nbsp;|&nbsp;</span><a href='doaction.php?a=del&id={$rows['id']}' target='mainFrame' onFocus='this.blur()' class='add'>删除</a>
                                  </td>";
                                echo "</tr>";
                            }

                        }

                    }
//                    mysqli_free_result($res);
                    mysqli_close($link);
                }else{
                    $link = mysqli_connect("localhost","root","") or die("数据连接失败");
                    mysqli_set_charset($link,"utf8");
                    mysqli_select_db($link,"bbs");
                    $where = @$_GET['name'];
                    $sql = "select post.*,user.userName,type.name from post,user,type where post.uid =user.id and post.tid=type.id and recycle='1' and title like '%{$where}%' order by top desc,ctime desc ";
                    $res = mysqli_query($link,$sql);
                    $count = mysqli_num_rows($res);//总条数；
                    $pages = ceil($count/10);//总页数；
                    $page = isset($_GET['p']) ? $_GET['p'] : 1;
                    if ($page < 1) {//限定最小页数；
                        $page = 1;
                    }
                    if ($page > $count) {//限定最大页数；
                        $page = $count;
                    }
                    $index = ($page - 1) * 10;//获取起始下标；
                    $sql = "select post.*,user.userName,type.name from post,user,type where post.uid =user.id and post.tid=type.id and recycle='1' and title like '%{$where}%' order by top desc,ctime desc limit $index,10";
                    $res = mysqli_query($link,$sql);
                    if($res && mysqli_num_rows($res)>0){
                        while($rows=mysqli_fetch_assoc($res)) {


                                    $time = date('Y-m-d H:i:s', time());
                                    echo "<tr onMouseOut='this.style.backgroundColor='#ffffff'' onMouseOver='this.style.backgroundColor='#edf5ff''>";
                                    echo "<td align='center' valign='middle' class='borderright borderbottom'>{$rows['id']}</td>";
                                    echo "<td align='center' valign='middle' class='borderright borderbottom'>{$rows['title']}</td>";
                                    echo "<td align='center' valign='middle' class='borderright borderbottom'>{$rows['userName']}</td>";
                                    echo "<td align='center' valign='middle' class='borderright borderbottom'>{$rows['name']}</td>";
                                    echo "<td align='center' valign='middle' class='borderright borderbottom'>" . '发布' . "</td>";
                                    echo "<td align='center' valign='middle' class='borderright borderbottom'>{$time}</td>";
                                    echo "<td align='center' valign='middle' class='borderbottom'><a href='doaction.php?a=recover&id={$rows['id']}' target='mainFrame' onFocus='this.blur()' class='add'>恢复</a>
                                        <span class='gray'>&nbsp;|&nbsp;</span><a href='doaction.php?a=del&id={$rows['id']}' target='mainFrame' onFocus='this.blur()' class='add'>删除</a>
                                    </td>";
                                    echo "</tr>";



                        }
                    }
                    mysqli_free_result($res);
                    mysqli_close($link);
                }

                ?>



            </table></td>
    </tr>


</table>
<br>
<div style="margin-left: 400px">
    <ul style="list-style: none;">
        <li style="float: left">当前数据:<?php echo $count;?>条,</li>
        <li style="float:left">第<?php echo $page;?>/<?php echo $pages;?>页,</li>
        <li style="float:left"><a href="return.php?p=1&name=<?php echo @$_GET['name']?>">首页</a>&nbsp;</li>
        <li style="float:left"><a href="return.php?p=<?php echo $page-1;?>&name=<?php echo @$_GET['name']?>">上一页</a>&nbsp;</li>
        <li style="float:left"><a href="return.php?p=<?php echo $page+1>$pages?$pages:$page+1;?>&name=<?php echo @$_GET['name']?>">下一页</a>&nbsp;</li>
        <li style="float:left"><a href="return.php?p=<?php echo $pages;?>&name=<?php echo @$_GET['name']?>">尾页</a>&nbsp;</li>
    </ul>
</div>
</body>
</html>